Dataset statistics
| Number of variables | 21 |
|---|---|
| Number of observations | 1000 |
| Missing cells | 171 |
| Missing cells (%) | 0.8% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 396.7 KiB |
| Average record size in memory | 406.2 B |
Variable types
| NUM | 12 |
|---|---|
| BOOL | 4 |
| CAT | 4 |
| DATE | 1 |
Reproduction
| Analysis started | 2020-08-20 12:56:35.177499 |
|---|---|
| Analysis finished | 2020-08-20 12:57:05.488512 |
| Duration | 30.31 seconds |
| Version | pandas-profiling v2.7.1 |
| Command line | pandas_profiling --config_file config.yaml [YOUR_FILE.csv] |
| Download configuration | config.yaml |
Store is highly correlated with df_index | High correlation |
df_index is highly correlated with Store | High correlation |
Customers is highly correlated with Sales | High correlation |
Sales is highly correlated with Customers | High correlation |
sales_per_customer has 171 (17.1%) missing values | Missing |
df_index has unique values | Unique |
Sales has 171 (17.1%) zeros | Zeros |
Customers has 171 (17.1%) zeros | Zeros |
| Distinct count | 1000 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 503563.579 |
|---|---|
| Minimum | 827 |
| Maximum | 1015129 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 7.9 KiB |
Quantile statistics
| Minimum | 827 |
|---|---|
| 5-th percentile | 59821.25 |
| Q1 | 260922.75 |
| median | 488470 |
| Q3 | 752031 |
| 95-th percentile | 960340.75 |
| Maximum | 1015129 |
| Range | 1014302 |
| Interquartile range (IQR) | 491108.25 |
Descriptive statistics
| Standard deviation | 285526.0505 |
|---|---|
| Coefficient of variation (CV) | 0.5670109245 |
| Kurtosis | -1.155248824 |
| Mean | 503563.579 |
| Median Absolute Deviation (MAD) | 241878 |
| Skewness | 0.05046897516 |
| Sum | 503563579 |
| Variance | 8.152512549e+10 |
| Value | Count | Frequency (%) | |
| 485374 | 1 | 0.1% | |
| 920241 | 1 | 0.1% | |
| 740100 | 1 | 0.1% | |
| 152261 | 1 | 0.1% | |
| 572100 | 1 | 0.1% | |
| 1002503 | 1 | 0.1% | |
| 431700 | 1 | 0.1% | |
| 246462 | 1 | 0.1% | |
| 469692 | 1 | 0.1% | |
| 919525 | 1 | 0.1% | |
| Other values (990) | 990 | 99.0% |
| Value | Count | Frequency (%) | |
| 827 | 1 | 0.1% | |
| 1441 | 1 | 0.1% | |
| 1519 | 1 | 0.1% | |
| 2117 | 1 | 0.1% | |
| 3649 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 1015129 | 1 | 0.1% | |
| 1013951 | 1 | 0.1% | |
| 1012717 | 1 | 0.1% | |
| 1011016 | 1 | 0.1% | |
| 1010994 | 1 | 0.1% |
| Distinct count | 665 |
|---|---|
| Unique (%) | 66.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 552.904 |
|---|---|
| Minimum | 1 |
| Maximum | 1113 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 7.9 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 65.95 |
| Q1 | 288 |
| median | 536 |
| Q3 | 826.25 |
| 95-th percentile | 1053.1 |
| Maximum | 1113 |
| Range | 1112 |
| Interquartile range (IQR) | 538.25 |
Descriptive statistics
| Standard deviation | 312.9912816 |
|---|---|
| Coefficient of variation (CV) | 0.5660861226 |
| Kurtosis | -1.15569261 |
| Mean | 552.904 |
| Median Absolute Deviation (MAD) | 264.5 |
| Skewness | 0.04978727165 |
| Sum | 552904 |
| Variance | 97963.54233 |
| Value | Count | Frequency (%) | |
| 281 | 5 | 0.5% | |
| 211 | 4 | 0.4% | |
| 678 | 4 | 0.4% | |
| 880 | 4 | 0.4% | |
| 291 | 4 | 0.4% | |
| 271 | 4 | 0.4% | |
| 268 | 4 | 0.4% | |
| 943 | 4 | 0.4% | |
| 441 | 4 | 0.4% | |
| 527 | 4 | 0.4% | |
| Other values (655) | 959 | 95.9% |
| Value | Count | Frequency (%) | |
| 1 | 1 | 0.1% | |
| 2 | 2 | 0.2% | |
| 3 | 1 | 0.1% | |
| 4 | 1 | 0.1% | |
| 6 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 1113 | 1 | 0.1% | |
| 1112 | 1 | 0.1% | |
| 1111 | 1 | 0.1% | |
| 1109 | 2 | 0.2% | |
| 1107 | 2 | 0.2% |
DayOfWeek
Real number (ℝ≥0)
| Distinct count | 7 |
|---|---|
| Unique (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.991 |
|---|---|
| Minimum | 1 |
| Maximum | 7 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 7.9 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 4 |
| Q3 | 6 |
| 95-th percentile | 7 |
| Maximum | 7 |
| Range | 6 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 1.969466374 |
|---|---|
| Coefficient of variation (CV) | 0.4934769165 |
| Kurtosis | -1.186803223 |
| Mean | 3.991 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 0.0401277736 |
| Sum | 3991 |
| Variance | 3.878797798 |
| Value | Count | Frequency (%) | |
| 4 | 160 | 16.0% | |
| 3 | 157 | 15.7% | |
| 7 | 146 | 14.6% | |
| 2 | 139 | 13.9% | |
| 5 | 138 | 13.8% | |
| 1 | 134 | 13.4% | |
| 6 | 126 | 12.6% |
| Value | Count | Frequency (%) | |
| 1 | 134 | 13.4% | |
| 2 | 139 | 13.9% | |
| 3 | 157 | 15.7% | |
| 4 | 160 | 16.0% | |
| 5 | 138 | 13.8% |
| Value | Count | Frequency (%) | |
| 7 | 146 | 14.6% | |
| 6 | 126 | 12.6% | |
| 5 | 138 | 13.8% | |
| 4 | 160 | 16.0% | |
| 3 | 157 | 15.7% |
Date
Date
| Distinct count | 615 |
|---|---|
| Unique (%) | 61.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.9 KiB |
| Minimum | 2013-01-01 00:00:00 |
|---|---|
| Maximum | 2015-07-31 00:00:00 |
| Distinct count | 790 |
|---|---|
| Unique (%) | 79.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5651.73 |
|---|---|
| Minimum | 0 |
| Maximum | 16331 |
| Zeros | 171 |
| Zeros (%) | 17.1% |
| Memory size | 7.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 3882.75 |
| median | 5745.5 |
| Q3 | 7848.5 |
| 95-th percentile | 11562.75 |
| Maximum | 16331 |
| Range | 16331 |
| Interquartile range (IQR) | 3965.75 |
Descriptive statistics
| Standard deviation | 3515.341922 |
|---|---|
| Coefficient of variation (CV) | 0.6219939598 |
| Kurtosis | -0.2589751912 |
| Mean | 5651.73 |
| Median Absolute Deviation (MAD) | 1969.5 |
| Skewness | 0.05063180166 |
| Sum | 5651730 |
| Variance | 12357628.83 |
| Value | Count | Frequency (%) | |
| 0 | 171 | 17.1% | |
| 7135 | 3 | 0.3% | |
| 5432 | 3 | 0.3% | |
| 8383 | 3 | 0.3% | |
| 3863 | 3 | 0.3% | |
| 7303 | 2 | 0.2% | |
| 9565 | 2 | 0.2% | |
| 6020 | 2 | 0.2% | |
| 5703 | 2 | 0.2% | |
| 5178 | 2 | 0.2% | |
| Other values (780) | 807 | 80.7% |
| Value | Count | Frequency (%) | |
| 0 | 171 | 17.1% | |
| 1032 | 1 | 0.1% | |
| 1685 | 1 | 0.1% | |
| 1736 | 1 | 0.1% | |
| 1847 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 16331 | 1 | 0.1% | |
| 15537 | 1 | 0.1% | |
| 15535 | 1 | 0.1% | |
| 15171 | 1 | 0.1% | |
| 15077 | 1 | 0.1% |
| Distinct count | 542 |
|---|---|
| Unique (%) | 54.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 605.101 |
|---|---|
| Minimum | 0 |
| Maximum | 1868 |
| Zeros | 171 |
| Zeros (%) | 17.1% |
| Memory size | 7.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 409.5 |
| median | 622.5 |
| Q3 | 817 |
| 95-th percentile | 1292.1 |
| Maximum | 1868 |
| Range | 1868 |
| Interquartile range (IQR) | 407.5 |
Descriptive statistics
| Standard deviation | 383.820561 |
|---|---|
| Coefficient of variation (CV) | 0.6343082576 |
| Kurtosis | 0.1920091675 |
| Mean | 605.101 |
| Median Absolute Deviation (MAD) | 204.5 |
| Skewness | 0.2422526649 |
| Sum | 605101 |
| Variance | 147318.223 |
| Value | Count | Frequency (%) | |
| 0 | 171 | 17.1% | |
| 523 | 6 | 0.6% | |
| 635 | 6 | 0.6% | |
| 491 | 5 | 0.5% | |
| 641 | 5 | 0.5% | |
| 501 | 5 | 0.5% | |
| 700 | 5 | 0.5% | |
| 643 | 4 | 0.4% | |
| 668 | 4 | 0.4% | |
| 717 | 4 | 0.4% | |
| Other values (532) | 785 | 78.5% |
| Value | Count | Frequency (%) | |
| 0 | 171 | 17.1% | |
| 176 | 1 | 0.1% | |
| 182 | 1 | 0.1% | |
| 209 | 1 | 0.1% | |
| 210 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 1868 | 1 | 0.1% | |
| 1842 | 1 | 0.1% | |
| 1841 | 1 | 0.1% | |
| 1814 | 1 | 0.1% | |
| 1795 | 1 | 0.1% |
Open
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.9 KiB |
| 1 | |
|---|---|
| 0 |
| Value | Count | Frequency (%) | |
| 1 | 829 | 82.9% | |
| 0 | 171 | 17.1% |
Promo
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.9 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 609 | 60.9% | |
| 1 | 391 | 39.1% |
StateHoliday
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.9 KiB |
| o | |
|---|---|
| a | 19 |
| c | 6 |
| b | 2 |
| Value | Count | Frequency (%) | |
| o | 973 | 97.3% | |
| a | 19 | 1.9% | |
| c | 6 | 0.6% | |
| b | 2 | 0.2% |
Length
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 4 | 100.0% |
| Value | Count | Frequency (%) | |
| Latin | 4 | 100.0% |
| Value | Count | Frequency (%) | |
| ASCII | 4 | 100.0% |
SchoolHoliday
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.9 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 822 | 82.2% | |
| 1 | 178 | 17.8% |
StoreType
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.9 KiB |
| a | |
|---|---|
| d | |
| c | |
| b | 11 |
| Value | Count | Frequency (%) | |
| a | 546 | 54.6% | |
| d | 326 | 32.6% | |
| c | 117 | 11.7% | |
| b | 11 | 1.1% |
Length
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 4 | 100.0% |
| Value | Count | Frequency (%) | |
| Latin | 4 | 100.0% |
| Value | Count | Frequency (%) | |
| ASCII | 4 | 100.0% |
Assortment
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.9 KiB |
| a | |
|---|---|
| c | |
| b | 7 |
| Value | Count | Frequency (%) | |
| a | 514 | 51.4% | |
| c | 479 | 47.9% | |
| b | 7 | 0.7% |
Length
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 3 | 100.0% |
| Value | Count | Frequency (%) | |
| Latin | 3 | 100.0% |
| Value | Count | Frequency (%) | |
| ASCII | 3 | 100.0% |
CompetitionDistance
Real number (ℝ≥0)
| Distinct count | 461 |
|---|---|
| Unique (%) | 46.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4927.62 |
|---|---|
| Minimum | 30.0 |
| Maximum | 27650.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 7.9 KiB |
Quantile statistics
| Minimum | 30 |
|---|---|
| 5-th percentile | 139.5 |
| Q1 | 760 |
| median | 2470 |
| Q3 | 6892.5 |
| 95-th percentile | 18540 |
| Maximum | 27650 |
| Range | 27620 |
| Interquartile range (IQR) | 6132.5 |
Descriptive statistics
| Standard deviation | 5813.044561 |
|---|---|
| Coefficient of variation (CV) | 1.179686048 |
| Kurtosis | 1.830858064 |
| Mean | 4927.62 |
| Median Absolute Deviation (MAD) | 2060 |
| Skewness | 1.596393661 |
| Sum | 4927620 |
| Variance | 33791487.07 |
| Value | Count | Frequency (%) | |
| 250 | 11 | 1.1% | |
| 350 | 8 | 0.8% | |
| 2710 | 8 | 0.8% | |
| 50 | 7 | 0.7% | |
| 550 | 7 | 0.7% | |
| 230 | 7 | 0.7% | |
| 1070 | 7 | 0.7% | |
| 2190 | 7 | 0.7% | |
| 1080 | 7 | 0.7% | |
| 190 | 7 | 0.7% | |
| Other values (451) | 924 | 92.4% |
| Value | Count | Frequency (%) | |
| 30 | 5 | 0.5% | |
| 40 | 5 | 0.5% | |
| 50 | 7 | 0.7% | |
| 60 | 3 | 0.3% | |
| 70 | 4 | 0.4% |
| Value | Count | Frequency (%) | |
| 27650 | 1 | 0.1% | |
| 27530 | 2 | 0.2% | |
| 27150 | 1 | 0.1% | |
| 26490 | 1 | 0.1% | |
| 26130 | 1 | 0.1% |
CompetitionOpenSinceMonth
Real number (ℝ≥0)
| Distinct count | 12 |
|---|---|
| Unique (%) | 1.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.827 |
|---|---|
| Minimum | 1.0 |
| Maximum | 12.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 7.9 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2.95 |
| Q1 | 6 |
| median | 9 |
| Q3 | 9 |
| 95-th percentile | 11 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 2.691154643 |
|---|---|
| Coefficient of variation (CV) | 0.3438296465 |
| Kurtosis | -0.2322506994 |
| Mean | 7.827 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | -0.8127326447 |
| Sum | 7827 |
| Variance | 7.242313313 |
| Value | Count | Frequency (%) | |
| 9 | 465 | 46.5% | |
| 4 | 79 | 7.9% | |
| 11 | 77 | 7.7% | |
| 7 | 64 | 6.4% | |
| 10 | 51 | 5.1% | |
| 3 | 50 | 5.0% | |
| 12 | 48 | 4.8% | |
| 6 | 46 | 4.6% | |
| 5 | 42 | 4.2% | |
| 2 | 35 | 3.5% | |
| Other values (2) | 43 | 4.3% |
| Value | Count | Frequency (%) | |
| 1 | 15 | 1.5% | |
| 2 | 35 | 3.5% | |
| 3 | 50 | 5.0% | |
| 4 | 79 | 7.9% | |
| 5 | 42 | 4.2% |
| Value | Count | Frequency (%) | |
| 12 | 48 | 4.8% | |
| 11 | 77 | 7.7% | |
| 10 | 51 | 5.1% | |
| 9 | 465 | 46.5% | |
| 8 | 28 | 2.8% |
CompetitionOpenSinceYear
Real number (ℝ≥0)
| Distinct count | 20 |
|---|---|
| Unique (%) | 2.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2009.496 |
|---|---|
| Minimum | 1900.0 |
| Maximum | 2015.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 7.9 KiB |
Quantile statistics
| Minimum | 1900 |
|---|---|
| 5-th percentile | 2002 |
| Q1 | 2008 |
| median | 2011 |
| Q3 | 2011 |
| 95-th percentile | 2014 |
| Maximum | 2015 |
| Range | 115 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 5.378746593 |
|---|---|
| Coefficient of variation (CV) | 0.002676664494 |
| Kurtosis | 184.3885348 |
| Mean | 2009.496 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | -10.28430612 |
| Sum | 2009496 |
| Variance | 28.93091491 |
| Value | Count | Frequency (%) | |
| 2011 | 398 | 39.8% | |
| 2014 | 70 | 7.0% | |
| 2012 | 64 | 6.4% | |
| 2013 | 57 | 5.7% | |
| 2007 | 56 | 5.6% | |
| 2005 | 56 | 5.6% | |
| 2010 | 54 | 5.4% | |
| 2009 | 52 | 5.2% | |
| 2006 | 45 | 4.5% | |
| 2008 | 36 | 3.6% | |
| Other values (10) | 112 | 11.2% |
| Value | Count | Frequency (%) | |
| 1900 | 1 | 0.1% | |
| 1961 | 2 | 0.2% | |
| 1990 | 4 | 0.4% | |
| 1999 | 2 | 0.2% | |
| 2000 | 7 | 0.7% |
| Value | Count | Frequency (%) | |
| 2015 | 30 | 3.0% | |
| 2014 | 70 | 7.0% | |
| 2013 | 57 | 5.7% | |
| 2012 | 64 | 6.4% | |
| 2011 | 398 | 39.8% |
Promo2
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.9 KiB |
| 1 | |
|---|---|
| 0 |
| Value | Count | Frequency (%) | |
| 1 | 518 | 51.8% | |
| 0 | 482 | 48.2% |
Promo2SinceWeek
Real number (ℝ≥0)
| Distinct count | 21 |
|---|---|
| Unique (%) | 2.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 18.415 |
|---|---|
| Minimum | 1.0 |
| Maximum | 50.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 7.9 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 5 |
| Q1 | 14 |
| median | 14 |
| Q3 | 18 |
| 95-th percentile | 40 |
| Maximum | 50 |
| Range | 49 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 10.99143242 |
|---|---|
| Coefficient of variation (CV) | 0.5968738755 |
| Kurtosis | 0.4139670615 |
| Mean | 18.415 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.176794421 |
| Sum | 18415 |
| Variance | 120.8115866 |
| Value | Count | Frequency (%) | |
| 14 | 562 | 56.2% | |
| 40 | 55 | 5.5% | |
| 10 | 38 | 3.8% | |
| 5 | 36 | 3.6% | |
| 37 | 36 | 3.6% | |
| 1 | 35 | 3.5% | |
| 18 | 32 | 3.2% | |
| 31 | 31 | 3.1% | |
| 22 | 31 | 3.1% | |
| 13 | 29 | 2.9% | |
| Other values (11) | 115 | 11.5% |
| Value | Count | Frequency (%) | |
| 1 | 35 | 3.5% | |
| 5 | 36 | 3.6% | |
| 6 | 1 | 0.1% | |
| 9 | 20 | 2.0% | |
| 10 | 38 | 3.8% |
| Value | Count | Frequency (%) | |
| 50 | 1 | 0.1% | |
| 48 | 11 | 1.1% | |
| 45 | 24 | 2.4% | |
| 44 | 5 | 0.5% | |
| 40 | 55 | 5.5% |
Promo2SinceYear
Real number (ℝ≥0)
| Distinct count | 7 |
|---|---|
| Unique (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2011.355 |
|---|---|
| Minimum | 2009.0 |
| Maximum | 2015.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 7.9 KiB |
Quantile statistics
| Minimum | 2009 |
|---|---|
| 5-th percentile | 2009 |
| Q1 | 2011 |
| median | 2011 |
| Q3 | 2012 |
| 95-th percentile | 2014 |
| Maximum | 2015 |
| Range | 6 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1.215916713 |
|---|---|
| Coefficient of variation (CV) | 0.0006045261593 |
| Kurtosis | 0.8004152121 |
| Mean | 2011.355 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 0.7550592501 |
| Sum | 2011355 |
| Variance | 1.478453453 |
| Value | Count | Frequency (%) | |
| 2011 | 622 | 62.2% | |
| 2013 | 103 | 10.3% | |
| 2012 | 73 | 7.3% | |
| 2014 | 71 | 7.1% | |
| 2009 | 61 | 6.1% | |
| 2010 | 59 | 5.9% | |
| 2015 | 11 | 1.1% |
| Value | Count | Frequency (%) | |
| 2009 | 61 | 6.1% | |
| 2010 | 59 | 5.9% | |
| 2011 | 622 | 62.2% | |
| 2012 | 73 | 7.3% | |
| 2013 | 103 | 10.3% |
| Value | Count | Frequency (%) | |
| 2015 | 11 | 1.1% | |
| 2014 | 71 | 7.1% | |
| 2013 | 103 | 10.3% | |
| 2012 | 73 | 7.3% | |
| 2011 | 622 | 62.2% |
PromoInterval
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.9 KiB |
| Jan,Apr,Jul,Oct | |
|---|---|
| Feb,May,Aug,Nov | 123 |
| Mar,Jun,Sept,Dec | 100 |
| Value | Count | Frequency (%) | |
| Jan,Apr,Jul,Oct | 777 | 77.7% | |
| Feb,May,Aug,Nov | 123 | 12.3% | |
| Mar,Jun,Sept,Dec | 100 | 10.0% |
Length
| Max length | 16 |
|---|---|
| Mean length | 15.1 |
| Min length | 15 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 14 | 60.9% | |
| Uppercase_Letter | 8 | 34.8% | |
| Other_Punctuation | 1 | 4.3% |
| Value | Count | Frequency (%) | |
| Latin | 22 | 95.7% | |
| Common | 1 | 4.3% |
| Value | Count | Frequency (%) | |
| ASCII | 23 | 100.0% |
month
Real number (ℝ≥0)
| Distinct count | 12 |
|---|---|
| Unique (%) | 1.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.821 |
|---|---|
| Minimum | 1 |
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 7.9 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 6 |
| Q3 | 8 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 3.408897121 |
|---|---|
| Coefficient of variation (CV) | 0.5856205327 |
| Kurtosis | -1.042538365 |
| Mean | 5.821 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 0.2833487739 |
| Sum | 5821 |
| Variance | 11.62057958 |
| Value | Count | Frequency (%) | |
| 1 | 112 | 11.2% | |
| 2 | 105 | 10.5% | |
| 7 | 103 | 10.3% | |
| 6 | 100 | 10.0% | |
| 5 | 93 | 9.3% | |
| 3 | 92 | 9.2% | |
| 4 | 91 | 9.1% | |
| 12 | 72 | 7.2% | |
| 8 | 62 | 6.2% | |
| 11 | 61 | 6.1% | |
| Other values (2) | 109 | 10.9% |
| Value | Count | Frequency (%) | |
| 1 | 112 | 11.2% | |
| 2 | 105 | 10.5% | |
| 3 | 92 | 9.2% | |
| 4 | 91 | 9.1% | |
| 5 | 93 | 9.3% |
| Value | Count | Frequency (%) | |
| 12 | 72 | 7.2% | |
| 11 | 61 | 6.1% | |
| 10 | 61 | 6.1% | |
| 9 | 48 | 4.8% | |
| 8 | 62 | 6.2% |
| Distinct count | 829 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 171 |
| Missing (%) | 17.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9.601078294965776 |
|---|---|
| Minimum | 3.6750871080139373 |
| Maximum | 17.48175182481752 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 7.9 KiB |
Quantile statistics
| Minimum | 3.675087108 |
|---|---|
| 5-th percentile | 6.532093883 |
| Q1 | 7.982791587 |
| median | 9.411067194 |
| Q3 | 10.95709571 |
| 95-th percentile | 13.74064806 |
| Maximum | 17.48175182 |
| Range | 13.80666472 |
| Interquartile range (IQR) | 2.974304123 |
Descriptive statistics
| Standard deviation | 2.218568376 |
|---|---|
| Coefficient of variation (CV) | 0.2310749176 |
| Kurtosis | 0.1609142098 |
| Mean | 9.601078295 |
| Median Absolute Deviation (MAD) | 1.463609567 |
| Skewness | 0.5190732953 |
| Sum | 7959.293907 |
| Variance | 4.922045639 |
| Value | Count | Frequency (%) | |
| 11.39563438 | 1 | 0.1% | |
| 7.984168865 | 1 | 0.1% | |
| 10.88076312 | 1 | 0.1% | |
| 6.773491592 | 1 | 0.1% | |
| 10.56507937 | 1 | 0.1% | |
| 9.438998957 | 1 | 0.1% | |
| 8.317200298 | 1 | 0.1% | |
| 9.532544379 | 1 | 0.1% | |
| 11.65037594 | 1 | 0.1% | |
| 7.7 | 1 | 0.1% | |
| Other values (819) | 819 | 81.9% | |
| (Missing) | 171 | 17.1% |
| Value | Count | Frequency (%) | |
| 3.675087108 | 1 | 0.1% | |
| 4.028846154 | 1 | 0.1% | |
| 4.11010453 | 1 | 0.1% | |
| 4.37366167 | 1 | 0.1% | |
| 4.780044101 | 1 | 0.1% |
| Value | Count | Frequency (%) | |
| 17.48175182 | 1 | 0.1% | |
| 17.26457399 | 1 | 0.1% | |
| 16.81946625 | 1 | 0.1% | |
| 16.39049236 | 1 | 0.1% | |
| 15.83527132 | 1 | 0.1% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.First rows
| df_index | Store | DayOfWeek | Date | Sales | Customers | Open | Promo | StateHoliday | SchoolHoliday | StoreType | Assortment | CompetitionDistance | CompetitionOpenSinceMonth | CompetitionOpenSinceYear | Promo2 | Promo2SinceWeek | Promo2SinceYear | PromoInterval | month | sales_per_customer | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1010994 | 1109 | 6 | 2015-01-17 | 3328 | 315 | 1 | 0 | o | 0 | c | a | 3490.0 | 4.0 | 2011.0 | 1 | 22.0 | 2012.0 | Jan,Apr,Jul,Oct | 1 | 10.565079 |
| 1 | 433317 | 475 | 7 | 2014-06-01 | 0 | 0 | 0 | 0 | o | 0 | a | a | 140.0 | 9.0 | 2005.0 | 0 | 14.0 | 2011.0 | Jan,Apr,Jul,Oct | 6 | NaN |
| 2 | 281004 | 310 | 6 | 2014-12-13 | 9739 | 809 | 1 | 0 | o | 0 | a | c | 2290.0 | 9.0 | 2011.0 | 1 | 10.0 | 2014.0 | Mar,Jun,Sept,Dec | 12 | 12.038319 |
| 3 | 316424 | 348 | 3 | 2013-12-18 | 12225 | 906 | 1 | 1 | o | 0 | a | a | 16490.0 | 9.0 | 2011.0 | 1 | 22.0 | 2012.0 | Jan,Apr,Jul,Oct | 12 | 13.493377 |
| 4 | 315963 | 347 | 7 | 2013-02-24 | 0 | 0 | 0 | 0 | o | 0 | d | c | 9360.0 | 7.0 | 2013.0 | 1 | 22.0 | 2012.0 | Mar,Jun,Sept,Dec | 2 | NaN |
| 5 | 277645 | 306 | 3 | 2013-10-30 | 4151 | 464 | 1 | 0 | o | 1 | a | a | 5100.0 | 4.0 | 2007.0 | 1 | 40.0 | 2014.0 | Jan,Apr,Jul,Oct | 10 | 8.946121 |
| 6 | 544903 | 598 | 3 | 2015-07-22 | 4886 | 673 | 1 | 0 | o | 0 | c | a | 550.0 | 12.0 | 2013.0 | 1 | 40.0 | 2014.0 | Jan,Apr,Jul,Oct | 7 | 7.260030 |
| 7 | 251179 | 277 | 7 | 2015-07-12 | 0 | 0 | 0 | 0 | o | 0 | d | c | 7840.0 | 9.0 | 2011.0 | 1 | 31.0 | 2009.0 | Feb,May,Aug,Nov | 7 | NaN |
| 8 | 966281 | 1060 | 5 | 2015-02-13 | 7433 | 855 | 1 | 0 | o | 0 | a | c | 3430.0 | 9.0 | 2011.0 | 1 | 31.0 | 2013.0 | Feb,May,Aug,Nov | 2 | 8.693567 |
| 9 | 655250 | 720 | 7 | 2013-06-23 | 0 | 0 | 0 | 0 | o | 0 | a | c | 15320.0 | 3.0 | 2011.0 | 1 | 14.0 | 2013.0 | Feb,May,Aug,Nov | 6 | NaN |
Last rows
| df_index | Store | DayOfWeek | Date | Sales | Customers | Open | Promo | StateHoliday | SchoolHoliday | StoreType | Assortment | CompetitionDistance | CompetitionOpenSinceMonth | CompetitionOpenSinceYear | Promo2 | Promo2SinceWeek | Promo2SinceYear | PromoInterval | month | sales_per_customer | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 990 | 292769 | 322 | 5 | 2013-03-08 | 5862 | 597 | 1 | 1 | o | 0 | a | a | 17500.0 | 4.0 | 2001.0 | 1 | 37.0 | 2009.0 | Jan,Apr,Jul,Oct | 3 | 9.819095 |
| 991 | 633191 | 695 | 2 | 2013-06-04 | 6534 | 644 | 1 | 1 | o | 0 | a | a | 550.0 | 7.0 | 2011.0 | 1 | 1.0 | 2012.0 | Jan,Apr,Jul,Oct | 6 | 10.145963 |
| 992 | 688715 | 757 | 2 | 2015-04-07 | 6920 | 654 | 1 | 0 | o | 1 | a | c | 3450.0 | 9.0 | 2011.0 | 0 | 14.0 | 2011.0 | Jan,Apr,Jul,Oct | 4 | 10.581040 |
| 993 | 517459 | 568 | 7 | 2015-05-03 | 0 | 0 | 0 | 0 | o | 0 | d | c | 4270.0 | 9.0 | 2011.0 | 1 | 1.0 | 2013.0 | Jan,Apr,Jul,Oct | 5 | NaN |
| 994 | 463499 | 508 | 1 | 2013-05-13 | 7905 | 721 | 1 | 1 | o | 0 | a | c | 1280.0 | 9.0 | 2011.0 | 1 | 40.0 | 2011.0 | Jan,Apr,Jul,Oct | 5 | 10.963939 |
| 995 | 702008 | 771 | 5 | 2013-12-20 | 10197 | 1043 | 1 | 1 | o | 0 | a | a | 20640.0 | 9.0 | 2007.0 | 0 | 14.0 | 2011.0 | Jan,Apr,Jul,Oct | 12 | 9.776606 |
| 996 | 623582 | 685 | 4 | 2014-06-12 | 5592 | 570 | 1 | 0 | o | 0 | a | a | 650.0 | 11.0 | 2013.0 | 1 | 37.0 | 2009.0 | Jan,Apr,Jul,Oct | 6 | 9.810526 |
| 997 | 826738 | 908 | 3 | 2015-03-25 | 3080 | 307 | 1 | 0 | o | 0 | a | a | 1980.0 | 7.0 | 2010.0 | 1 | 37.0 | 2009.0 | Jan,Apr,Jul,Oct | 3 | 10.032573 |
| 998 | 411915 | 452 | 6 | 2014-09-13 | 3045 | 292 | 1 | 0 | o | 0 | a | c | 1850.0 | 8.0 | 2013.0 | 1 | 5.0 | 2011.0 | Feb,May,Aug,Nov | 9 | 10.428082 |
| 999 | 72328 | 80 | 6 | 2015-04-04 | 10578 | 844 | 1 | 0 | o | 0 | d | a | 7910.0 | 9.0 | 2011.0 | 0 | 14.0 | 2011.0 | Jan,Apr,Jul,Oct | 4 | 12.533175 |